Skip to main content

Lookup example

The following example shows how a lookup table is used to concatenate a Dutch translation of the category name (located in the lookup table) to the original category name located in the landing table.

The lookup could be defined using the following expressions:

  1. Condition expression: ${Lookup.CategoryID}=${Landing.CategoryID}

    Meaning: Perform the lookup only if the Category ID in the landing table and the lookup table are the same.

  2. Result column expression: ${Lookup.CategoryName} + ’is’ + ${Landing.CategoryName}

    Meaning: Add the data in the CategoryName column in the lookup table to the data in the CategoryName column in the landing table (separated by the word "is").

Example:  

Assuming the result column name is "Split Name", clicking the Preview Results button would display the following table:

Example table output
Split Name Category Name (Lookup) Category Name (Landing) Category ID (Lookup) Category ID (Landing)

dranken is Beverages

dranken

Beverages

1

1

Specerijen is Condiments

Specerijen

Condiments

2

2

Gebak is Confectionary

Gebak

Confectionary

3

3

Zuivelproducten is Dairy Products

Zuivelproducten

Dairy Products

4

4

Grains/Granen is Grains/Cereal

Grains/Granen

Grains/Cereal

5

5

Vlees/Gevolgete is Meat/Poultry

Vlees/Gevolgete

Meat/Poultry

6

6

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!